SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 46243: Including the report name and filter information when exporting data from a graph or table from SAS® Web Report Studio to Microsoft Excel

DetailsAboutRate It

By default, when exporting data from a table or graph, the exported content does not include the report name, applied filter information, the section name, or the object title.

However, if you are running version 4.31_M2, you can include the report name and filter information, as explained next. (There is no way to include the section name or object title.)

Include the report name

Make the following changes to the SAS Web Report Studio properties in SAS® Management Console in order to show the report name.

  1. On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure.
  2. Right-click on Web Report Studio 4.3 and select Properties to open the Web Report Studio 4.3 Properties dialog box.
  3. Click the Advanced tab.
  4. Click Add to open the Define New Property dialog box.
    • For the Property Name, enter wrs.addReportNameToExport
    • For the Property Value, enter true
  5. Click OK twice to exit both dialog boxes and save the changes.
  6. Restart your web application server to enforce the new setting.

Note: When you export the entire report, the report name is not included in the output.

Include filter information

In order to include the filter information, in SAS Web Report Studio, open the report, select File ► Properties, click the Formats tab, and select the Display filter information option.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioMicrosoft Windows Server 2008 for x644.24.31_M29.2 TS2M09.3 TS1M2
Microsoft Windows Server 2003 for x644.24.31_M29.2 TS2M09.3 TS1M2
Microsoft Windows Server 2003 Standard Edition4.24.31_M29.2 TS2M09.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition4.24.31_M29.2 TS2M09.3 TS1M2
Microsoft Windows Server 2003 Datacenter Edition4.24.31_M29.2 TS2M09.3 TS1M2
Microsoft® Windows® for x644.24.31_M29.2 TS2M09.3 TS1M2
Microsoft Windows XP Professional4.24.31_M29.2 TS2M09.3 TS1M2
Windows Vista4.24.31_M29.2 TS2M09.3 TS1M2
Windows Vista for x644.24.31_M29.2 TS2M09.3 TS1M2
64-bit Enabled AIX4.24.31_M29.2 TS2M09.3 TS1M2
64-bit Enabled Solaris4.24.31_M29.2 TS2M09.3 TS1M2
HP-UX IPF4.24.31_M29.2 TS2M09.3 TS1M2
Linux for x644.24.31_M29.2 TS2M09.3 TS1M2
Solaris for x644.24.31_M29.2 TS2M09.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.